﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using HK2009.EntityQuery;
using System.Collections;

namespace HK2009.BusinessFacade
{
    public interface IBNBookingHandler
    {
        /// <summary>
        /// 根据sql语句同参数获取列表
        /// </summary>
        /// <param name="sqlStr"></param>
        /// <param name="parms"></param>
        /// <returns></returns>
        DataTable GetList(string sqlStr, SqlParameter[] parms);

        bool BookingAdd(string sqlStr, SqlParameter[] parms, ref int bookingid);

        bool UpdateBookingStatus(string sqlStr, SqlParameter[] parms);

        BN_BookingQuery GetBookingByID(int pkid);

        BN_BookingDtlQuery GetBookingDtlByDtlID(int dtlId);

        bool BookingArrange(string[] strSql, ArrayList parms);

        bool BookingArrange2(string strSql, SqlParameter[] parms);

        bool BookingCancelArrange(string strSql, SqlParameter[] parms);

        bool UpdateDetail(int id, string jobDate, string user,object userId, bool isComapnyUser);

        DataTable GetBookingDtlByBookingNoteDtlID(int bookingnoteDtlID);

        string GetAppointament(string jobDate);

        object GetObjectBySql(string sql, SqlParameter[] parms);
    }
}
